Tables [dbo].[RuleSourceDesign]
SQLServer > iMIS1521GA > Tables > dbo.RuleSourceDesign
Properties
PropertyValue
Created10:31:37 AM Tuesday, March 02, 2010
Last Modified11:40:07 AM Monday, February 20, 2012
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_RuleSourceDesign: RuleNameRuleNamenvarchar(100)200
No
RuleCodentextmax
Yes
CreatedOndatetime8
No
(getdate())
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_RuleSourceDesign: RuleNamePK_RuleSourceDesignRuleName
Yes
SQL Script
CREATE TABLE [dbo].[RuleSourceDesign]
(
[RuleName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[RuleCode] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreatedOn] [datetime] NOT NULL CONSTRAINT [DF_RuleSourceDesign_CreatedOn] DEFAULT (getdate())
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[RuleSourceDesign] ADD CONSTRAINT [PK_RuleSourceDesign] PRIMARY KEY CLUSTERED ([RuleName]) ON [PRIMARY]
GO
Uses
Used By
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved